SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Don't miss this incredible chance to own a piece of one of the Upper Valley's most desirable villages. Located just minutes from Hanover, Dartmouth College, and the Dartmouth-Hitchcock Medical Center, Etna offers small-town charm with easy access to shopping, dining, and top-rated schools. This is your chance to build equity and create something special in one of the region's most desirable communities. Please note: This home is not currently in livable condition and will require full renovation or rebuilding. Ideal for contractors, builders, or buyers with vision looking to create their dream home in an unbeatable location. Cash or construction/renovation financing only. Sold strictly as-is. Proof of funds or rehab/construction loan pre-qualification letter required prior to scheduling showing.
Description:Location, convenience, and classic New England charm! This 2-bedroom, 1-bath 1910 home puts you right in the heart of it all. Just steps from the Rail Trail, you can easily head out for a morning walk, run, or bike ride, while Colburn Park and the Lebanon Mall are within walking distance for shopping, dining, community events, and more. Inside, the home offers a comfortable and manageable layout with the character you'd expect from an early 1900s home. Outside, the small city lot provides just enough space to enjoy without spending your weekends on yard work. A one-car garage adds valuable off-street parking and additional storage. Whether you're looking for your first home, hoping to downsize, or simply want the convenience of being close to downtown Lebanon, this property offers an opportunity to enjoy an easy, in-town lifestyle with recreation and amenities right outside your door.
Description:Welcome to 32 S Main Street, a thoughtfully renovated residence situated in the heart of West Lebanon, NH. This distinctive property offers a refined blend of modern updates and classic New England character. The interior features generous, well-appointed living spaces designed to accommodate both everyday living and entertaining with ease. The sizable bedrooms offer views of the Connecticut River and the Vermont countryside — a serene and picturesque outlook to greet each morning. The bathrooms have been tastefully updated throughout, with the ensuite showcasing custom tile work that reflects a true attention to detail. Recent updates extend to the kitchen appliances as well, and a brand-new propane furnace, installed in December 2025, ensures peace of mind heading into the years ahead. The property's location is among its finest attributes. Situated within close proximity to West Lebanon's shops, restaurants, and cultural amenities, residents enjoy the full convenience of in-town living without sacrificing comfort or quality. For those seeking a well-maintained, move-in-ready home with character and convenience in the heart of the Upper Valley, 32 S Main Street is a property worthy of your consideration. Showings start at the open house on Saturday, July 18th, from 1:30 PM – 3:30 PM.
Description:Classic Cape With Spacious Garage & Paved Driveway. Front Screened Porch, Rear Screened Porch/Entrance Room. Kitchen Leads To Dining/Living Room W/Ceiling Fans & Entrance To Front Screened Porch. 1st Floor Den/Office Can Be A Bedroom. Full Bath W/Washer & Dryer. 3 Bedrooms & 1/2 Bath on 2nd Floor. This In Town Home Allows Walking To Conveniences, Employment & Recreation.
Description:Welcome home to this lovingly maintained 1940 Cape offering 3 bedrooms and 1.5 bathrooms. This charming home blends classic character with thoughtful updates, including an updated kitchen, beautiful hardwood floors, and a convenient first-floor primary bedroom. The inviting mudroom provides the perfect transition from the attached one-car garage into the home, while the finished walk-out basement offers additional living space for a family room, home office, or recreation area. Step outside to enjoy a spacious backyard designed for relaxing and entertaining. Cool off in the above-ground pool, or let the kids enjoy the playground area. A large barn provides plenty of storage for recreational vehicles, equipment, hobbies, or all your outdoor toys. This well loved Cape is ready to welcome its next owners. Super location.